import xlrd
def read_add_data():
    data = []
    wb = xlrd.open_workbook(filename=r"新calc测试数据.xls")
    sheet = wb.sheet_by_index(0)
    for i in range(1,10):
        row = sheet.row_values(i)[0:3]
        data.append(row)
    return data
def read_sub_data():
    data = []
    wb = xlrd.open_workbook(filename=r"新calc测试数据.xls")
    sheet = wb.sheet_by_index(1)
    for i in range(1,10):
        row = sheet.row_values(i)[0:3]
        data.append(row)
    return data
def read_mul_data():
    data = []
    wb = xlrd.open_workbook(filename=r"新calc测试数据.xls")
    sheet = wb.sheet_by_index(2)
    for i in range(1,10):
        row = sheet.row_values(i)[0:3]
        data.append(row)
    return data
def read_div_data():
    data = []
    wb = xlrd.open_workbook(filename=r"新calc测试数据.xls")
    sheet = wb.sheet_by_index(3)
    for i in range(1,10):
        row = sheet.row_values(i)[0:3]
        data.append(row)
    return data
#print(read_add_data())
if __name__=='__main__':
    read_add_data()
    print(data)
    # read_add_data()
    # read_add_data()
    # read_add_data()